Report of French Employment, Salaries, Population

Table of Contents

1. Basic info

Dataset is coming from INSEE. INSEE is the official french institute gathering data of many types around France. It can be demographic (Births, Deaths, Population Density…), Economic (Salary, Firms by activity / size…) and more. Data and descriptin can be found at this link. Four files are in the dataset:

baseetablissementpartrancheeffectif : give information on the number of firms in every french town, categorized by size , come from INSEE.

namegeographicinformation : give geographic data on french town (mainly latitude and longitude, but also region / department codes and names )

netsalarypertownper_category : salaries around french town per job categories, age and sex

population : demographic information in France per town, age, sex and living mode

departments.geojson : contains the borders of french departments. From Gregoire David (github)

This report is using only netsalarypertownper_category and name_geographic_information parts. Other files are described for further analysis purposes if needed. These datasets can be merged by : CODGEO = code_insee.

2. Data loading and cleaning

3. Data analysis

3.1. Current French labour market information

3.1.1. The unemployment rate

In Q1 2021 the unemployment rate in France has reached 8.1%.

3.1.2. Mean salary for France

3.1.3. Mean salary by working position

3.1.4. Mean salary by age

Net payment is starting to grow with the age. The discrepancies between gender payments are getting more visible with the age.

3.2. Labour situation by regions

3.2.1. Mean salary per region

Some of France Regions have been merged during last period. Data have been updated to reflect those changes and new Region names.

3.2.2. Regions with the lowest and highest salaries

3.2.3. Salary per region and gender

3.3. Labour situation by cities

3.3.1. Mean salary per town

3.3.2. Mean salary per town and gender

In the whole country there are only two towns where is noted higher average payment for women than men. However, the difference is slight.

3.3.3. Mean salary per town and age